Running the Audit_03 Detail Charges to Billing report

This report summarizes Cost Detail Volume and Charge totals (only chargeable items at this point) for monthly validation to the billing source system based on the posting date of Cost Items for a selected month and entity.

The Detail Charges to Billing report allows for validation of Cost Detail data (chargeable items with a Unit Charge value) through comparison of summed volume and charges by department.

To run the Audit_03 Detail Charged to Billing report:

  1. In the Explorer task pane, in the Libraries section, click Costing Reports > Data Import Validations, and double-click Audit_03 Detail Charged to Billing report.

  2. Refresh variables by doing one of the following:

    • In the Main tab, in the Workbook Options section, click Refresh Data.

    • Press F9.

  3. In the Refresh Variables dialog, do the following, and click OK:

    Option Description
    Select Entity (leave blank for all)(optional)

    Select the one or more entities.
    Select Calendar Year and Month Select the year and month.

After you select variables, the report populates total volume and charges by department for the selected calendar year and month.

To validate the data pulled into the Cost Detail, generate a report from the source system, validating between the source and Cost Detail table. When you compare this data to the data of the billing source system:

  • This should tie-out completely.
  • Differences could be due to filtering issues with source system extract creation.

    • NOTE: If these extracts are not matching the reporting from source system, you may need to update the extracts.

  • There could also be timing differences in the billing system versus the encounter source system.